/*
MySQL Backup
Database: tianyu_cms
Backup Time: 2021-10-23 23:38:08
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `tianyu_cms`.`adv`;
DROP TABLE IF EXISTS `tianyu_cms`.`adv_position`;
DROP TABLE IF EXISTS `tianyu_cms`.`article`;
DROP TABLE IF EXISTS `tianyu_cms`.`article_category`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_config`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_dictionary`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_login_log`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_menu`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_role`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_role_menu`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_user`;
DROP TABLE IF EXISTS `tianyu_cms`.`sys_user_role`;
CREATE TABLE `adv` (
  `Id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `adv_position_id` bigint NOT NULL COMMENT '广告位ID',
  `adv_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '广告名称',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态',
  `jmp_url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '跳转Url',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `adv_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '广告图片',
  `adv_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '广告描述',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='广告';
CREATE TABLE `adv_position` (
  `Id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '广告位名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '广告位编码',
  `height` int DEFAULT NULL COMMENT '长(px)',
  `width` int DEFAULT NULL COMMENT '宽(px)',
  `status` int NOT NULL COMMENT '状态',
  `adv_type` int NOT NULL COMMENT '广告类型（1＝单图片；2＝多图片）',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='广告位';
CREATE TABLE `article` (
  `guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'guid',
  `category_id` int NOT NULL COMMENT '分类Id',
  `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'keywords',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'description',
  `article_title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '副标题',
  `title_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题图片',
  `content` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章内容',
  `pulish_status` int NOT NULL DEFAULT '0' COMMENT '发布状态（0＝未发布，1＝已发布）',
  `is_top` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否置顶（0＝否；1＝是）',
  `is_recommend` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否推荐（0＝否；1＝是）',
  `is_original` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否原创（0＝否；1＝是）',
  `pv_count` int NOT NULL DEFAULT '0' COMMENT '浏览量',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人Guid',
  PRIMARY KEY (`guid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `article_category` (
  `Id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
  `sort` int NOT NULL DEFAULT '0' COMMENT '排序',
  `parent_id` int DEFAULT NULL COMMENT '父类Id',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人Guid',
  `level` int NOT NULL DEFAULT '1' COMMENT '层级',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `sys_config` (
  `config_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置项编码',
  `config_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置项内容',
  PRIMARY KEY (`config_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `sys_dictionary` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `dictionary_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
  `dictionary_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典编码',
  `parent_id` int NOT NULL COMMENT '父级Id（-1=顶级）',
  `sort` int NOT NULL DEFAULT '1' COMMENT '排序',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人Guid',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `sys_login_log` (
  `Id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `action_type` int NOT NULL COMMENT '执行类型（1＝登录；2＝退出）',
  `operator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '执行人',
  `exec_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '执行IP',
  `exec_time` datetime NOT NULL COMMENT '执行时间',
  `exec_content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '执行内容',
  `exec_result` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '执行结果',
  `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统登录日志';
CREATE TABLE `sys_menu` (
  `Id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
  `menu_code` int NOT NULL COMMENT '菜单编码',
  `menu_icon` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单图标',
  `menu_type` int DEFAULT NULL COMMENT '菜单类型（1＝系统；2＝目录；3＝菜单；4＝按钮）',
  `menu_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单Url',
  `parent_id` int NOT NULL COMMENT '父级ID(-1为顶级)',
  `parent_code` int DEFAULT NULL COMMENT '父级编码',
  `enabled` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否启用',
  `level` int NOT NULL COMMENT '层级',
  `js_event` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Js事件名称',
  `back_color` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '背景颜色',
  `size_style` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '按钮样式',
  `group_id` int NOT NULL DEFAULT '0' COMMENT '分组',
  `sort` int NOT NULL COMMENT '排序',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人Guid',
  `is_toolbar` bit(1) NOT NULL COMMENT '是否自定义',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统菜单';
CREATE TABLE `sys_role` (
  `Id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `role_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `role_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色编号',
  `role_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色描述',
  `sort` int NOT NULL COMMENT '排序',
  `enabled` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否启用',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人Guid',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统角色';
CREATE TABLE `sys_role_menu` (
  `role_id` int NOT NULL COMMENT '角色Id',
  `menu_id` int NOT NULL COMMENT '菜单Id',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统角色菜单';
CREATE TABLE `sys_user` (
  `guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'guid',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `user_pwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户密码',
  `salt_value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '盐值',
  `true_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `gender` int NOT NULL DEFAULT '0' COMMENT '性别（0＝不详；1＝男；2＝女）',
  `head_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态（0＝有效；1＝无效）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人Guid',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `modifier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `modify_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人Guid',
  `enabled` bit(1) DEFAULT NULL COMMENT '状态（0＝启用；1＝禁用）',
  PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户';
CREATE TABLE `sys_user_role` (
  `user_guid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户Id',
  `role_id` int NOT NULL COMMENT '角色Id',
  PRIMARY KEY (`user_guid`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户角色';
BEGIN;
LOCK TABLES `tianyu_cms`.`adv` WRITE;
DELETE FROM `tianyu_cms`.`adv`;
INSERT INTO `tianyu_cms`.`adv` (`Id`,`adv_position_id`,`adv_name`,`start_time`,`end_time`,`status`,`jmp_url`,`create_time`,`adv_img`,`adv_desc`) VALUES (1, 1, '456456', '2021-08-31 00:00:00', '2021-10-20 00:00:00', 0, NULL, NULL, '/UploadFile\\202109\\20210926-1446-5428-9a91-baceb4f4c272.jpg', NULL),(2, 2, '图片广告', '2021-09-24 00:00:00', '2021-10-25 00:00:00', 0, 'http:www.baidu.com', NULL, '/UploadFile\\202109\\20210926-1720-1773-b321-8e14d855d697.jpg', NULL),(3, 3, '会员认证位广告', '2021-09-16 00:00:00', '2021-10-18 00:00:00', 0, NULL, '2021-09-26 15:00:19', '/UploadFile\\202109\\20210926-1500-17d2-b5c5-12114bb474da.jpg', NULL),(4, 4, '1234', '2021-09-07 00:00:00', '2021-10-20 00:00:00', 0, NULL, '2021-09-26 15:01:13', '/UploadFile\\202109\\20210926-1501-116d-89bf-b4e02b2811dd.jpg', NULL),(5, 5, '132', '2021-09-07 00:00:00', '2021-10-28 00:00:00', 0, NULL, '2021-09-26 15:01:24', '/UploadFile\\202109\\20210926-1501-22ce-ae2e-1f61170afcbf.jpg', NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`adv_position` WRITE;
DELETE FROM `tianyu_cms`.`adv_position`;
INSERT INTO `tianyu_cms`.`adv_position` (`Id`,`name`,`code`,`height`,`width`,`status`,`adv_type`) VALUES (1, '首页轮播广告', 'IndexRotation', 500, 1200, 0, 0),(2, '首页资讯广告', 'IndexNew', 500, 1200, 0, 0),(3, '首页会员认证广告', 'IndexAuth', 500, 1200, 0, 0),(4, '首页问题左边广告', 'IndexQuL', 500, 1200, 0, 0),(5, '首页问题右边广告', 'IndexQuR', 500, 1200, 0, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`article` WRITE;
DELETE FROM `tianyu_cms`.`article`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`article_category` WRITE;
DELETE FROM `tianyu_cms`.`article_category`;
INSERT INTO `tianyu_cms`.`article_category` (`Id`,`name`,`sort`,`parent_id`,`status`,`create_time`,`creator`,`create_guid`,`modify_time`,`modifier`,`modify_guid`,`level`) VALUES (19, '摄影', 1, -1, 0, '2021-09-27 14:55:03', 'administrator', '1', NULL, NULL, NULL, 1),(20, '生活', 2, -1, 0, '2021-09-27 14:55:25', 'administrator', '1', NULL, NULL, NULL, 1),(21, '婚姻', 3, -1, 0, '2021-09-27 14:56:24', 'administrator', '1', NULL, NULL, NULL, 1);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_config` WRITE;
DELETE FROM `tianyu_cms`.`sys_config`;
INSERT INTO `tianyu_cms`.`sys_config` (`config_code`,`config_content`) VALUES ('baseConfig', '{\"SysName\":\"管理后台\",\"SEOTitle\":\"草堂笔记技术文章分享\",\"Keywords\":\".NET Core,.NET开发,.NET Core开发,WebAPI,SqSugar,MVC,Redis,ORM,Web前端,分布式,微服务\",\"Description\":\".NET开发、.NET Core开发技术、WebAPI、SqSugar、MVC、Redis、ORM、Web前端、微服务、软件设计、数据库技术、操作系统等技术/文章分享。\",\"AppId\":\"草堂笔记\",\"AppSecret\":null,\"WxNotifyUrl\":\"http://loc\",\"MchId\":\"123\",\"PayKey\":\"123\"}');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_dictionary` WRITE;
DELETE FROM `tianyu_cms`.`sys_dictionary`;
INSERT INTO `tianyu_cms`.`sys_dictionary` (`id`,`dictionary_name`,`dictionary_code`,`parent_id`,`sort`,`status`,`create_time`,`creator`,`create_guid`,`modify_time`,`modifier`,`modify_guid`) VALUES (1, '性别', 'Gender', -1, 1, 0, '2021-10-23 23:02:08', 'administrator', '1', NULL, NULL, NULL),(2, '男', '1', 1, 1, 0, '2021-10-23 23:03:43', 'administrator', '1', NULL, NULL, NULL),(3, '女', '2', 1, 2, 0, '2021-10-23 23:03:51', 'administrator', '1', NULL, NULL, NULL),(4, '不详', '3', 1, 3, 0, '2021-10-23 23:04:03', 'administrator', '1', NULL, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_login_log` WRITE;
DELETE FROM `tianyu_cms`.`sys_login_log`;
INSERT INTO `tianyu_cms`.`sys_login_log` (`Id`,`action_type`,`operator`,`exec_ip`,`exec_time`,`exec_content`,`exec_result`,`remark`) VALUES (72, 1, 'administrator', '127.0.0.1', '2021-10-23 21:16:05', '', '登录失败；失败原因：输入的验证码错误', NULL),(73, 1, 'administrator', '127.0.0.1', '2021-10-23 21:16:17', '', '登录失败；失败原因：用户名或密码错误', NULL),(74, 1, 'administrator', '127.0.0.1', '2021-10-23 21:16:29', '', '登录成功', NULL),(75, 1, 'administrator', '127.0.0.1', '2021-10-23 21:45:16', '', '登录成功', NULL),(76, 1, 'administrator', '127.0.0.1', '2021-10-23 23:26:19', '', '登录成功', NULL),(77, 1, 'administrator', '127.0.0.1', '2021-10-23 23:32:12', '', '登录成功', NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_menu` WRITE;
DELETE FROM `tianyu_cms`.`sys_menu`;
INSERT INTO `tianyu_cms`.`sys_menu` (`Id`,`menu_name`,`menu_code`,`menu_icon`,`menu_type`,`menu_url`,`parent_id`,`parent_code`,`enabled`,`level`,`js_event`,`back_color`,`size_style`,`group_id`,`sort`,`status`,`create_time`,`creator`,`create_guid`,`modify_time`,`modifier`,`modify_guid`,`is_toolbar`) VALUES (1, '系统管理', 10, 'layui-icon-set', 1, NULL, -1, NULL, b'1', 0, NULL, NULL, 'layui-btn-sm', 1, 99, 0, '2021-09-11 17:08:19', 'administrator', '1', NULL, NULL, NULL, b'0'),(2, '用户管理', 1010, NULL, 3, 'sysUser/Index', 1, 10, b'1', 0, NULL, NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-11 17:09:51', 'administrator', '1', NULL, NULL, NULL, b'0'),(3, '添加', 101010, 'layui-icon-add-1', 4, NULL, 2, 1010, b'1', 0, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-11 17:10:40', 'administrator', '1', NULL, NULL, NULL, b'0'),(4, '编辑', 101011, 'layui-icon-edit', 4, NULL, 2, 1010, b'1', 0, 'edit', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-18 13:46:41', 'administrator', '1', NULL, NULL, NULL, b'0'),(5, '菜单管理', 1020, NULL, 3, 'sysMenu/Index', 1, 10, b'1', 2, ' ', NULL, NULL, 0, 1, 0, '2021-09-11 17:09:51', 'administrator', '1', NULL, NULL, NULL, b'0'),(6, '添加', 0, 'layui-icon-add-1', 4, NULL, 5, 1020, b'1', 0, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-11 17:09:51', 'administrator', '1', NULL, NULL, NULL, b'0'),(7, '编辑', 0, 'layui-icon-edit', 4, NULL, 5, NULL, b'1', 0, 'edit', NULL, 'layui-btn-xs', 2, 3, 0, '2021-09-11 17:09:51', 'administrator', '1', NULL, NULL, NULL, b'0'),(8, '角色管理', 1030, NULL, 3, 'sysRole/Index', 1, 10, b'1', 2, ' ', NULL, NULL, 2, 1, 0, '2021-09-11 17:09:51', 'administrator', '1', NULL, NULL, NULL, b'0'),(9, '添加', 103010, 'layui-icon-add-1', 4, NULL, 8, 1030, b'1', 0, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-11 17:10:40', 'administrator', '1', NULL, NULL, NULL, b'0'),(10, '编辑', 103011, 'layui-icon-edit', 4, NULL, 8, 1030, b'1', 0, 'edit', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-18 13:46:41', 'administrator', '1', NULL, NULL, NULL, b'0'),(11, '保存', 0, 'layui-icon-list', 4, 'admin/sysrole/SaveRolePower', 8, NULL, b'1', 0, 'save', NULL, 'layui-btn-sm', 2, 3, 0, '2021-09-22 11:26:23', 'administrator', '1', NULL, NULL, NULL, b'1'),(12, '添加', 0, 'layui-icon-add-1', 4, NULL, 8, NULL, b'1', 0, 'add', NULL, 'layui-btn-xs', 2, 2, 1, '2021-09-22 14:03:29', 'administrator', '1', NULL, NULL, NULL, b'0'),(13, '添加', 0, 'layui-icon-add-1', 4, NULL, 5, NULL, b'1', 0, 'add', NULL, 'layui-btn-xs', 2, 2, 0, '2021-09-22 14:04:08', 'administrator', '1', NULL, NULL, NULL, b'0'),(14, '删除', 0, 'layui-icon-close', 4, NULL, 5, NULL, b'1', 0, 'del', 'layui-btn-danger', 'layui-btn-xs', 2, 4, 0, '2021-09-22 14:05:11', 'administrator', '1', NULL, NULL, NULL, b'1'),(15, '文章管理', 0, 'layui-icon-template-1', 2, '0', -1, NULL, b'1', 0, 'news', NULL, 'layui-btn-sm', 2, 1, 0, '2021-09-22 15:51:33', 'administrator', '1', NULL, NULL, NULL, b'1'),(16, '分类管理', 0, NULL, 3, 'ArticleCategory/Index', 15, NULL, b'1', 0, 'type', NULL, NULL, 0, 1, 0, '2021-09-22 15:52:19', 'administrator', '1', NULL, NULL, NULL, b'1'),(17, '系统配置', 1031, NULL, 2, 'SysConfig/Index', 1, 10, b'1', 0, NULL, NULL, 'layui-btn-sm', 1, 5, 0, '2021-09-26 18:13:18', 'administrator', '1', NULL, NULL, NULL, b'0'),(18, '保存', 103110, 'layui-icon-list', 4, NULL, 17, 1031, b'1', 0, 'formSubmit', NULL, 'layui-btn-sm', 1, 0, 0, '2021-09-26 18:13:56', 'administrator', '1', '2021-10-23 23:00:54', 'administrator', '1', b'0'),(19, '登录日志', 1032, NULL, 3, 'SysLoginLog/Index', 1, 10, b'1', 2, NULL, NULL, 'layui-btn-sm', 1, 5, 0, '2021-09-26 18:14:58', 'administrator', '1', NULL, NULL, NULL, b'0'),(20, '文章管理', 10, NULL, 3, 'Article/Index', 15, 0, b'1', 1, NULL, NULL, 'layui-btn-sm', 1, 2, 0, '2021-09-27 15:52:27', 'administrator', '1', NULL, NULL, NULL, b'0'),(21, '字典管理', 1033, NULL, 3, 'SysDictionary/Index', 1, 10, b'1', 0, NULL, NULL, 'layui-btn-sm', 1, 4, 0, '2021-09-27 15:53:56', 'administrator', '1', NULL, NULL, NULL, b'0'),(22, '添加', 103310, 'layui-icon-add-1', 4, NULL, 21, 1033, b'1', 1, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-09-27 15:54:55', 'administrator', '1', NULL, NULL, NULL, b'0'),(23, '编辑', 103311, 'layui-icon-edit', 4, NULL, 21, 1033, b'1', 1, 'edit', NULL, 'layui-btn-sm', 1, 2, 0, '2021-09-27 15:55:11', 'administrator', '1', NULL, NULL, NULL, b'0'),(24, '广告管理', 20, 'layui-icon-speaker', 2, NULL, -1, 0, b'1', 1, NULL, NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 21:48:36', 'administrator', '1', NULL, NULL, NULL, b'0'),(25, '广告位管理', 2010, NULL, 3, 'AdvPosition/Index', 24, 20, b'1', 0, NULL, NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 21:49:06', 'administrator', '1', NULL, NULL, NULL, b'0'),(26, '广告管理', 2010, NULL, 3, 'Adv/Index', 24, 20, b'1', 2, NULL, NULL, 'layui-btn-sm', 1, 1, 0, '2021-10-23 21:49:06', 'administrator', '1', NULL, NULL, NULL, b'0'),(27, '添加', 10, 'layui-icon-add-1', 4, NULL, 16, 0, b'1', 1, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-10-23 21:50:44', 'administrator', '1', NULL, NULL, NULL, b'0'),(28, '编辑', 11, 'layui-icon-edit', 4, NULL, 16, 0, b'1', 1, 'edit', NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 21:51:16', 'administrator', '1', NULL, NULL, NULL, b'0'),(29, '删除', 12, 'layui-icon-close', 4, NULL, 16, 0, b'1', 0, 'del', 'layui-btn-danger', 'layui-btn-sm', 1, 3, 0, '2021-10-23 21:51:32', 'administrator', '1', NULL, NULL, NULL, b'0'),(30, '添加', 1010, 'layui-icon-add-1', 4, NULL, 20, 10, b'1', 2, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-10-23 21:51:49', 'administrator', '1', NULL, NULL, NULL, b'0'),(31, '编辑', 1011, 'layui-icon-edit', 4, NULL, 20, 10, b'1', 2, 'edit', NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 21:52:10', 'administrator', '1', NULL, NULL, NULL, b'0'),(32, '删除', 1012, 'layui-icon-close', 4, NULL, 20, 10, b'1', 2, 'del', 'layui-btn-danger', 'layui-btn-sm', 1, 3, 0, '2021-10-23 21:52:30', 'administrator', '1', NULL, NULL, NULL, b'0'),(33, '添加', 201010, 'layui-icon-add-1', 4, NULL, 26, 2010, b'1', 3, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-10-23 21:52:55', 'administrator', '1', NULL, NULL, NULL, b'0'),(34, '编辑', 201011, 'layui-icon-edit', 4, NULL, 26, 2010, b'1', 3, 'edit', NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 21:53:14', 'administrator', '1', NULL, NULL, NULL, b'0'),(35, '删除', 201012, 'layui-icon-close', 4, NULL, 26, 2010, b'1', 3, 'del', 'layui-btn-danger', 'layui-btn-sm', 1, 3, 0, '2021-10-23 21:53:29', 'administrator', '1', NULL, NULL, NULL, b'0'),(36, '添加', 201010, 'layui-icon-add-1', 4, NULL, 25, 2010, b'1', 1, 'add', NULL, 'layui-btn-sm', 1, 1, 0, '2021-10-23 21:59:38', 'administrator', '1', NULL, NULL, NULL, b'0'),(37, '编辑', 201011, 'layui-icon-edit', 4, NULL, 25, 2010, b'1', 1, 'edit', NULL, 'layui-btn-sm', 1, 2, 0, '2021-10-23 22:00:01', 'administrator', '1', NULL, NULL, NULL, b'0'),(38, '添加', 103312, 'layui-icon-add-1', 4, NULL, 21, 1033, b'1', 1, 'add', NULL, 'layui-btn-sm', 2, 3, 0, '2021-10-23 23:02:37', 'administrator', '1', NULL, NULL, NULL, b'0'),(39, '编辑', 103312, 'layui-icon-edit', 4, NULL, 21, 1033, b'1', 0, 'edit', NULL, 'layui-btn-sm', 2, 4, 0, '2021-10-23 23:02:37', 'administrator', '1', '2021-10-23 23:03:27', 'administrator', '1', b'0');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_role` WRITE;
DELETE FROM `tianyu_cms`.`sys_role`;
INSERT INTO `tianyu_cms`.`sys_role` (`Id`,`role_name`,`role_code`,`role_desc`,`sort`,`enabled`,`status`,`create_time`,`creator`,`create_guid`,`modify_time`,`modifier`,`modify_guid`) VALUES (1, '管理员', 'admin', NULL, 1, b'1', 0, '2021-09-18 13:45:05', '1', '1', '2021-09-18 13:45:10', '1', '1'),(2, '财务', NULL, NULL, 0, b'1', 0, '2021-09-18 15:30:59', 'administrator', '1', NULL, NULL, NULL),(3, '操作员', NULL, NULL, 0, b'1', 0, '2021-09-18 16:19:54', 'administrator', '1', NULL, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_role_menu` WRITE;
DELETE FROM `tianyu_cms`.`sys_role_menu`;
INSERT INTO `tianyu_cms`.`sys_role_menu` (`role_id`,`menu_id`) VALUES (1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 8),(1, 9),(1, 10),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_user` WRITE;
DELETE FROM `tianyu_cms`.`sys_user`;
INSERT INTO `tianyu_cms`.`sys_user` (`guid`,`user_name`,`user_pwd`,`salt_value`,`true_name`,`gender`,`head_img`,`status`,`create_time`,`creator`,`create_guid`,`modify_time`,`modifier`,`modify_guid`,`enabled`) VALUES ('1', 'administrator', 'edab4292dd0b885e87c1157d4bb6ecb019369aff', '20201112-0910-086e-b49a-0b1fbf3a850e', '张三', 0, '', 0, '2020-09-21 17:27:51', NULL, NULL, '2020-11-12 08:58:30', 'administrator', '1', b'0'),('20210918-1345-30b4-8d6a-664755f61c48', 'test', 'a3e3725dc74fa9d539d3ef6df4bbe8d730e62c58', '58007710-9', '123456', 0, NULL, 0, '2021-09-18 13:45:31', 'administrator', '1', '2021-10-23 23:27:31', 'administrator', '1', b'0'),('20210918-1550-5198-9986-1d2d66374dd1', 'admin', '9461911004cbdb3fe26a262bd185759a214798d9', 'ada50ea0-5', '123456', 0, NULL, 0, '2021-09-18 15:50:51', 'administrator', '1', '2021-10-23 23:27:18', 'administrator', '1', b'0');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `tianyu_cms`.`sys_user_role` WRITE;
DELETE FROM `tianyu_cms`.`sys_user_role`;
INSERT INTO `tianyu_cms`.`sys_user_role` (`user_guid`,`role_id`) VALUES ('20210918-1345-30b4-8d6a-664755f61c48', 2),('20210918-1550-5198-9986-1d2d66374dd1', 1);
UNLOCK TABLES;
COMMIT;
